1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
| 'Necessite d'activer la reference
'Microsoft ActiveX Data Objects x.x Library
'
Dim Cn As ADODB.Connection
Dim Fichier As String, Chemin As String
Chemin = "C:\dossier\excel"
Fichier = "maBase"
Set Cn = New ADODB.Connection
Cn.Open "Driver={Microsoft dBASE Driver (*.dbf)};DriverID=277;Dbq=" & _
Chemin & ";"
Cn.Execute "Create Table " & Fichier & " (champTexte TEXT(30), champNum INTEGER)"
Cn.Execute "Insert Into " & Fichier & " (champTexte, champNum) Values ('Donnee01', 1004599)"
Cn.Execute "Insert Into " & Fichier & " (champTexte, champNum) Values ('Donnee02', 435455)"
Cn.Close
Set Cn = Nothing |
Partager